package com.zzu.dao;

import com.zzu.model.SC;
import com.zzu.model.Student;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface IStudentDao {

    //根据账号和密码查询管学生账号
    public Student findStudent(@Param("id") String id, @Param("password") String password);

    //从视图中查看全部学生信息
    public List<Student> findAllStudents();

    //删除学生操作
    public boolean deleteStudent(@Param("id") String id);

    //增加学生操作
    public boolean addStudent(Student student);

    //根据id查找学生
    public Student findStudentById(String Sid);

    //查找学生选修课程的成绩
    public List<SC> findAllCourses(String sId);

}
